StudentEnrollmentTermSummaryRebuildLog

EntityType | Independent
Logical Entity Name | StudentEnrollmentTermSummaryRebuildLog
Default Table Name | AdEnrollTerm_RebuildRelationshipLog
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentEnrollmentTermSummaryRebuildLog Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
AdEnrollTerm_RebuildRelationshipLogID |  | INTEGER | NO |
RebuildDate |  | DATETIME | NO |
AdEnrollTermID |  | INTEGER | NO |
StudentEnrollmentPeriodId |  | INTEGER | NO |
TermId |  | INTEGER | YES |
Sequence |  | NUMERIC(4, 0) | YES |
DateBilled |  | DATETIME | YES |
CurGPA |  | NUMERIC(11, 6) | YES |
CurNumAvg |  | NUMERIC(11, 6) | YES |
CurCreditsAttempt |  | NUMERIC(9, 2) | YES |
CurCreditsEarned |  | NUMERIC(9, 2) | YES |
CurHoursAttempt |  | NUMERIC(9, 2) | YES |
CurHoursEarned |  | NUMERIC(9, 2) | YES |
CurGPAPoints |  | NUMERIC(9, 2) | YES |
CurMinutesAttended |  | NUMERIC(11, 2) | YES |
CurMinutesAbsent |  | NUMERIC(9, 2) | YES |
CumGPA |  | NUMERIC(11, 6) | YES |
CumNumAvg |  | NUMERIC(11, 6) | YES |
CumCreditsAttempt |  | NUMERIC(9, 2) | YES |
CumCreditsEarned |  | NUMERIC(9, 2) | YES |
CumHoursAttempt |  | NUMERIC(9, 2) | YES |
CumHoursEarned |  | NUMERIC(9, 2) | YES |
CumGPAPoints |  | NUMERIC(9, 2) | YES |
CumMinutesAttended |  | NUMERIC(11, 2) | YES |
CumMinutesAbsent |  | NUMERIC(9, 2) | YES |
TermCreditsSched |  | NUMERIC(9, 2) | YES |
TermHoursSched |  | NUMERIC(9, 2) | YES |
Comment |  | VARCHAR(255) | YES |
SAPStatus |  | CHAR(1) | YES |
AdAttStatID |  | INTEGER | YES |
HonorsDescrip |  | VARCHAR(50) | YES |
DateAdded |  | DATETIME | NO |
DateLstMod |  | DATETIME | NO |
UserID |  | INTEGER | NO |
AdHonorsID |  | INTEGER | YES |
AdSapStatusID |  | INTEGER | YES |
SyStudentID |  | INTEGER | YES |
CurMinutesMakeupAttended |  | INTEGER | YES |
CumMinutesMakeupAttended |  | INTEGER | YES |
CumGPACredits |  | NUMERIC(9, 2) | YES |
StudentCurGPA |  | NUMERIC(11, 6) | YES |
StudentCurCreditsAttempt |  | NUMERIC(11, 2) | YES |
StudentCurHoursAttempt |  | NUMERIC(11, 2) | YES |
StudentCurGPAPoints |  | NUMERIC(11, 2) | YES |
StudentCumGPA |  | NUMERIC(11, 6) | YES |
StudentCumCreditsAttempt |  | NUMERIC(11, 2) | YES |
StudentCumHoursAttempt |  | NUMERIC(11, 2) | YES |
StudentCumGPAPoints |  | NUMERIC(11, 2) | YES |
BGRndSetID |  | INTEGER | NO |
GradeLevelEval |  | BIT | NO |
GradeLevelEvalDate |  | DATETIME | YES |
TermRegCredits |  | NUMERIC(9, 2) | YES |
TermRegHours |  | NUMERIC(9, 2) | YES |
StudentCurCreditsEarned |  | NUMERIC(9, 2) | YES |
StudentCurHoursEarned |  | NUMERIC(9, 2) | YES |
StudentCumCreditsEarned |  | NUMERIC(9, 2) | YES |
StudentCumHoursEarned |  | NUMERIC(9, 2) | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |
StudentId |  | INTEGER | YES |

StudentEnrollmentTermSummaryRebuildLog Keys

Key Name | Key Type | Keys
AdEnrollTerm_RebuildRelationshipLog_SyStudentID_N_N_IDX | Inversion Entry | SyStudentID
PK_AdEnrollTerm_RebuildRelationshipLog_AdEnrollTerm_RebuildRelationshipLogID | PrimaryKey | AdEnrollTerm_RebuildRelationshipLogID
AdEnrollTerm_RebuildRelationshipLog_UserID_N_N_IDX | Inversion Entry | UserID
AdEnrollTerm_RebuildRelationshipLog_AdEnrollID_N_N_IDX | Inversion Entry | StudentEnrollmentPeriodId
AdEnrollTerm_RebuildRelationshipLog_AdTermID_N_N_IDX | Inversion Entry | TermId

StudentEnrollmentTermSummaryRebuildLog Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StudentEnrollmentPeriod | Non-Identifying | One To Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | SyStudentID | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | TermId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

StudentEnrollmentTermSummaryRebuildLog Check Constraints

Check Constraint Name | CheckConstraint

StudentEnrollmentTermSummaryRebuildLog Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentEnrollmentTermSummaryRebuildLog | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdEnrollTerm_RebuildRelationshipLog | NO |  |  |

StudentEnrollmentTermSummaryRebuildLog Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Grades/Attendance
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

StudentEnrollmentTermSummaryRebuildLog Data Movement Rules

Name | Type | Rule Text/Value